Evaluate(Object[]) Method

The args contains 3 - 4 items: lookup_value, table_array, row_index_num, [range_lookup].

Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

Table_array is a table of information in which data is looked up. Use a reference to a range or a range name.

Row_index_num is the row number in table_array from which the matching value will be returned.

[Range_lookup] is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match.

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object

'Usage
 
Dim instance As CalcHLookupFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)

public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 3 - 4 items: lookup_value, table_array, row_index_num, [range_lookup].

Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

Table_array is a table of information in which data is looked up. Use a reference to a range or a range name.

Row_index_num is the row number in table_array from which the matching value will be returned.

[Range_lookup] is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match.

Return Value

A System.Object value that indicates the evaluate result.

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

CalcHLookupFunction Class
CalcHLookupFunction Members
Overload List